Raw Request:
POST /listings/_search?pretty=true&error_trace=true&typed_keys=true
{"from":0,"query":{"bool":{"filter":[{"terms":{"systemid":[406,407]}},{"bool":{"must_not":[{"term":{"flag_publicsearch":{"value":false}}}]}},{"terms":{"type_search":[0,1]}},{"terms":{"type_transactiontype":[0,2]}}],"must":[{"match":{"location_city":{"operator":"and","query":"Estill"}}},{"multi_match":{"fields":["location_*","id_listingid"],"operator":"and","query":"SC","type":"cross_fields"}}]}},"size":25,"sort":[{"date_list":{"order":"desc"}}],"_source":{"includes":["systemid","detailtablename","id_listinguid","id_listingid","id_primarylistingoffice","id_primarylistingofficename","id_primarylistingagent","status_display","location_streetaddress","location_city","location_state","location_postalcode","bedrooms","bathrooms_total","price_list","price_closed","primaryimage","squarefootage","geo_coordinates","type_search","type_transactiontype","type_propertytype","type_status","obj_openhouses","date_list","remarks","flag_*"]}}
Raw Response:
{
"took" : 9,
"timed_out" : false,
"_shards" : {
"total" : 3,
"successful" : 3,
"skipped" : 0,
"failed" : 0
},
"hits" : {
"total" : {
"value" : 8,
"relation" : "eq"
},
"max_score" : null,
"hits" : [
{
"_index" : "listings_v1",
"_type" : "_doc",
"_id" : "406-1062107620",
"_score" : null,
"_source" : {
"status_display" : "Active",
"systemid" : 406,
"id_listinguid" : "1062107620",
"type_search" : 0,
"bathrooms_total" : 2,
"id_primarylistingagent" : "592001",
"type_status" : 0,
"flag_showstreetaddress" : true,
"flag_publicsearch" : true,
"location_state" : "SC",
"location_streetaddress" : "1164 3rd Street E",
"flag_internetadvertise" : true,
"price_list" : 149000.0,
"location_city" : "Estill",
"detailtablename" : "feed_7/Property",
"geo_coordinates" : {
"lon" : -81.226545,
"lat" : 32.753172
},
"id_primarylistingofficename" : "New River Realty",
"type_propertytype" : 0,
"date_list" : "2024-03-06T00:00:00",
"location_postalcode" : "29918",
"bedrooms" : 2,
"id_primarylistingoffice" : "592",
"squarefootage" : 881,
"id_listingid" : "442647",
"type_transactiontype" : 0
},
"sort" : [
1709683200000
]
},
{
"_index" : "listings_v1",
"_type" : "_doc",
"_id" : "406-1059938943",
"_score" : null,
"_source" : {
"status_display" : "Active",
"systemid" : 406,
"id_listinguid" : "1059938943",
"type_search" : 0,
"bathrooms_total" : 2,
"id_primarylistingagent" : "702632",
"type_status" : 0,
"flag_showstreetaddress" : true,
"flag_publicsearch" : true,
"location_state" : "SC",
"location_streetaddress" : "372 Tison Street",
"flag_internetadvertise" : false,
"price_list" : 177700.0,
"location_city" : "Estill",
"detailtablename" : "feed_7/Property",
"geo_coordinates" : {
"lon" : -81.240039,
"lat" : 32.745252
},
"id_primarylistingofficename" : "COAST PROFESSIONALS Brokered by EXP Realty",
"type_propertytype" : 0,
"date_list" : "2024-01-26T00:00:00",
"location_postalcode" : "29918",
"bedrooms" : 3,
"id_primarylistingoffice" : "901",
"squarefootage" : 1247,
"id_listingid" : "441518",
"type_transactiontype" : 0
},
"sort" : [
1706227200000
]
},
{
"_index" : "listings_v1",
"_type" : "_doc",
"_id" : "407-3yd-SBORGA-303216",
"_score" : null,
"_source" : {
"status_display" : "Active",
"systemid" : 407,
"id_listinguid" : "3yd-SBORGA-303216",
"type_search" : 0,
"bathrooms_total" : 2,
"id_primarylistingagent" : "425412",
"type_status" : 0,
"flag_showstreetaddress" : true,
"flag_publicsearch" : true,
"location_state" : "SC",
"location_streetaddress" : "836 Newton Corner Road",
"flag_internetadvertise" : true,
"price_list" : 239900.0,
"location_city" : "Estill",
"detailtablename" : "feed_8/Property",
"geo_coordinates" : {
"lon" : -81.192048,
"lat" : 32.725769
},
"id_primarylistingofficename" : "Keller Williams Coastal Area P",
"type_propertytype" : 20,
"date_list" : "2024-01-24T00:00:00",
"location_postalcode" : "29918",
"bedrooms" : 4,
"id_primarylistingoffice" : "850",
"squarefootage" : 2128,
"id_listingid" : "303216",
"type_transactiontype" : 0
},
"sort" : [
1706054400000
]
},
{
"_index" : "listings_v1",
"_type" : "_doc",
"_id" : "406-1058675873",
"_score" : null,
"_source" : {
"status_display" : "Active",
"systemid" : 406,
"id_listinguid" : "1058675873",
"type_search" : 0,
"bathrooms_total" : 2,
"id_primarylistingagent" : "322696",
"type_status" : 0,
"flag_showstreetaddress" : true,
"flag_publicsearch" : true,
"location_state" : "SC",
"location_streetaddress" : "836 Newton Corner Road",
"flag_internetadvertise" : true,
"price_list" : 239900.0,
"location_city" : "Estill",
"detailtablename" : "feed_7/Property",
"geo_coordinates" : {
"lon" : -81.192048,
"lat" : 32.725769
},
"id_primarylistingofficename" : "Keller Williams Realty",
"type_propertytype" : 20,
"date_list" : "2024-01-24T00:00:00",
"location_postalcode" : "29918",
"bedrooms" : 4,
"id_primarylistingoffice" : "322",
"squarefootage" : 2128,
"id_listingid" : "441451",
"type_transactiontype" : 0
},
"sort" : [
1706054400000
]
},
{
"_index" : "listings_v1",
"_type" : "_doc",
"_id" : "406-1046234932",
"_score" : null,
"_source" : {
"status_display" : "Active Under Contract",
"systemid" : 406,
"id_listinguid" : "1046234932",
"id_primarylistingofficename" : "COAST PROFESSIONALS Brokered by EXP Realty",
"type_search" : 0,
"type_propertytype" : 40,
"bathrooms_total" : 0,
"id_primarylistingagent" : "702632",
"date_list" : "2023-10-12T00:00:00",
"type_status" : 2,
"flag_showstreetaddress" : true,
"flag_publicsearch" : true,
"location_state" : "SC",
"location_streetaddress" : "00 Woodrow Road",
"location_postalcode" : "29918",
"flag_internetadvertise" : true,
"price_list" : 70000.0,
"id_primarylistingoffice" : "901",
"location_city" : "Estill",
"detailtablename" : "feed_7/Property",
"geo_coordinates" : {
"lon" : -81.263302,
"lat" : 32.696096
},
"id_listingid" : "439415",
"type_transactiontype" : 0
},
"sort" : [
1697068800000
]
},
{
"_index" : "listings_v1",
"_type" : "_doc",
"_id" : "407-3yd-SBORGA-293935",
"_score" : null,
"_source" : {
"status_display" : "Active",
"systemid" : 407,
"id_listinguid" : "3yd-SBORGA-293935",
"type_search" : 0,
"bathrooms_total" : 1,
"id_primarylistingagent" : "SCOTTSA",
"type_status" : 0,
"flag_showstreetaddress" : true,
"flag_publicsearch" : true,
"location_state" : "SC",
"location_streetaddress" : "1164 3rd Street E",
"flag_internetadvertise" : true,
"price_list" : 64700.0,
"location_city" : "Estill",
"detailtablename" : "feed_8/Property",
"geo_coordinates" : {
"lon" : -81.24205017089844,
"lat" : 32.75489044189453
},
"id_primarylistingofficename" : "Scott Realty Professionals",
"type_propertytype" : 19,
"date_list" : "2023-08-02T00:00:00",
"location_postalcode" : "29918",
"bedrooms" : 2,
"id_primarylistingoffice" : "1247",
"squarefootage" : 881,
"id_listingid" : "293935",
"type_transactiontype" : 0
},
"sort" : [
1690934400000
]
},
{
"_index" : "listings_v1",
"_type" : "_doc",
"_id" : "407-3yd-SBORGA-289063",
"_score" : null,
"_source" : {
"status_display" : "Active",
"systemid" : 407,
"id_listinguid" : "3yd-SBORGA-289063",
"id_primarylistingofficename" : "The HomesFinder Realty Group LLC",
"type_search" : 0,
"type_propertytype" : 40,
"bathrooms_total" : 0,
"id_primarylistingagent" : "430250",
"date_list" : "2023-05-31T00:00:00",
"type_status" : 0,
"flag_showstreetaddress" : true,
"flag_publicsearch" : true,
"location_state" : "SC",
"location_streetaddress" : "Tbd Browning Gate Road",
"location_postalcode" : "29918",
"bedrooms" : 0,
"flag_internetadvertise" : true,
"price_list" : 75000.0,
"id_primarylistingoffice" : "2814",
"location_city" : "Estill",
"detailtablename" : "feed_8/Property",
"geo_coordinates" : {
"lon" : -81.24205017089844,
"lat" : 32.75489044189453
},
"id_listingid" : "289063",
"type_transactiontype" : 0
},
"sort" : [
1685491200000
]
},
{
"_index" : "listings_v1",
"_type" : "_doc",
"_id" : "406-1033397062",
"_score" : null,
"_source" : {
"systemid" : 406,
"id_listinguid" : "1033397062",
"id_primarylistingofficename" : "Maxey Blackstream Christie's International Real Es",
"type_search" : 0,
"type_propertytype" : 0,
"bathrooms_total" : 3,
"id_primarylistingagent" : "597007",
"date_list" : "2023-02-10T00:00:00",
"type_status" : 0,
"flag_showstreetaddress" : true,
"flag_publicsearch" : true,
"location_state" : "SC",
"location_streetaddress" : "493 Knotty Pine Plantation",
"location_postalcode" : "29918",
"bedrooms" : 5,
"flag_internetadvertise" : true,
"price_list" : 1550000.0,
"id_primarylistingoffice" : "898",
"squarefootage" : 3700,
"location_city" : "Estill",
"detailtablename" : "feed_7/Property",
"geo_coordinates" : {
"lon" : -81.221298,
"lat" : 32.67245
},
"id_listingid" : "432371",
"type_transactiontype" : 0
},
"sort" : [
1675987200000
]
}
]
}
}